Integrated Medical Claims Processing and Enrollment Analytics
Database Overview
Data Owner: Data Products
Storage Format: delta
Total Tables: 3
Total Columns: 184
Total Storage Size: ~205 GB
This data warehouse contains healthcare data with semantic tables.
Table Summary
Semantic Tables (3 tables)
Semantic tables containing measurable business events and metrics.
Note: Please click on the table link and select the preview tab to see the column level information such as column name, data type and column description.
| Table Name | Primary Key | Columns | Row Count | Size (GB) | Description |
|---|---|---|---|---|---|
sem_merative_claim_summary | sem_claim_key | 111 | 1750577229 | 99.6928 | The table summarizes claims data related to healthcare services. It includes details such as claim identifiers, service dates, payment amounts, and patient demographics. This data can be used for analyzing claims processing, understanding service utilization, and evaluating financial aspects of healthcare delivery. Additionally, it provides insights into patient characteristics and service types, which can aid in demographic studies and healthcare planning. |
sem_merative_encounter_summary | sem_encounter_key | 30 | 1745133413 | 54.8237 | The table summarizes encounter data related to healthcare services provided to members. It includes details such as member identification, procedure codes, encounter dates, and various financial metrics associated with claims. This data can be used for analyzing healthcare utilization patterns, understanding financial responsibilities of members, and evaluating the types of services rendered. It is useful for assessing both inpatient and outpatient care, as well as for demographic analysis based on age and gender. |
sem_merative_enrollment_summary | sem_enrollment_key | 43 | 1728539610 | 50.259 | The table summarizes enrollment data for members, capturing key details about their health coverage and demographics. It includes information such as enrollment dates, member identifiers, coverage types, and demographic attributes like age, gender, and race. This data can be used for analyzing enrollment trends, understanding member engagement, and assessing health coverage options. Additionally, it supports demographic studies and helps in evaluating the health needs of different member segments. |
Notes
All these semantic tables use delta format for ACID compliance and these tables are created for the AI data explorer.